package com.opal.modules.costReportForm.mapper.sqlServercpd;

import org.apache.ibatis.annotations.Select;

public interface ArticlePrice {

        @Select("SELECT  top 1 sumPrice\n" +
                " FROM [CoptisPrixDist].[dbo].[CompositionEssais] CompositionEssais \n" +
                " where 1=1 and dr=0  and \n" +
                " ( Upper(CodeFormule) =#{peiFangHao} ) \n" +
                "order by EssaisDate desc")
     String selectArticlePrice(String peiFangHao);
}
